package org.example.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.example.entity.TempPrice;

import java.util.List;
import java.util.Map;

/**
 * ============================================================<br>
 * <p> ProjectName ：dianguanjiaexportdata </p>
 * <p> @author dongjianzhao </p>
 * <p> @date 2023/3/18 </p>
 * <p> @version ：1.0 </p>
 * ============================================================<br>
 * <p>
 * TempPrice
 * </p>
 * ============================================================<br>
 */
@Mapper
public interface TempPriceMapper extends BaseMapper<TempPrice> {
    @Select("select * from temp_price")
    List<TempPrice> selectAll();
    @Select("select * from temp_price where priceType!='05'")
    List<TempPrice> selectPriceTypeNot05();
    @Select("SELECT i.* FROM ies_combo_price i   WHERE i.`capacitymin`=#{capacitymin} AND i.`capacitymax`=#{capacitymax}")
    Map<String, String> selectEmertypecode(@Param("capacitymin") String capacitymin,@Param("capacitymax") String capacitymax);
    @Select("SELECT i.* FROM ies_combo_price i   WHERE i.`id`=#{priceType} ")
    Map<String, String> selectEmertypecode(@Param("priceType") String priceType);
}
